Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 2290424 |
| Missing cells | 3494900 |
| Missing cells (%) | 7.6% |
| Duplicate rows | 62785 |
| Duplicate rows (%) | 2.7% |
| Total size in memory | 1.8 GiB |
| Average record size in memory | 838.9 B |
Variable types
| Text | 4 |
|---|---|
| Numeric | 7 |
| Categorical | 7 |
| DateTime | 1 |
| URL | 1 |
| Dataset has 62785 (2.7%) duplicate rows | Duplicates |
drive is highly overall correlated with type | High correlation |
odometer is highly overall correlated with predicted_price and 1 other fields | High correlation |
predicted_price is highly overall correlated with odometer and 2 other fields | High correlation |
price is highly overall correlated with odometer and 1 other fields | High correlation |
type is highly overall correlated with drive | High correlation |
year is highly overall correlated with predicted_price | High correlation |
title is highly imbalanced (77.3%) | Imbalance |
fuel is highly imbalanced (75.7%) | Imbalance |
transmission is highly imbalanced (67.8%) | Imbalance |
make has 47044 (2.1%) missing values | Missing |
predicted_price has 577806 (25.2%) missing values | Missing |
residual has 577806 (25.2%) missing values | Missing |
condition has 369671 (16.1%) missing values | Missing |
model has 192028 (8.4%) missing values | Missing |
paint has 623480 (27.2%) missing values | Missing |
drive has 672749 (29.4%) missing values | Missing |
type has 434032 (18.9%) missing values | Missing |
Reproduction
| Analysis started | 2024-12-02 18:35:13.286845 |
|---|---|
| Analysis finished | 2024-12-02 18:39:08.107901 |
| Duration | 3 minutes and 54.82 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
location
Text
| Distinct | 413 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 123.7 MiB |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 7.6498159 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | orlando |
|---|---|
| 2nd row | atlanta |
| 3rd row | siouxfalls |
| 4th row | lasvegas |
| 5th row | dallas |
| Value | Count | Frequency (%) |
| miami | 203810 | 8.9% |
| sfbay | 142771 | 6.2% |
| losangeles | 104965 | 4.6% |
| phoenix | 93158 | 4.1% |
| portland | 65872 | 2.9% |
| seattle | 65548 | 2.9% |
| sandiego | 61523 | 2.7% |
| sacramento | 57187 | 2.5% |
| orangecounty | 51898 | 2.3% |
| dallas | 48695 | 2.1% |
| Other values (403) | 1394997 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2004700 | |
| e | 1667454 | 9.5% |
| n | 1557938 | 8.9% |
| o | 1491572 | 8.5% |
| s | 1357311 | 7.7% |
| i | 1251924 | 7.1% |
| l | 1201582 | 6.9% |
| t | 962888 | 5.5% |
| r | 820300 | 4.7% |
| m | 757930 | 4.3% |
| Other values (16) | 4447723 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17521322 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2004700 | |
| e | 1667454 | 9.5% |
| n | 1557938 | 8.9% |
| o | 1491572 | 8.5% |
| s | 1357311 | 7.7% |
| i | 1251924 | 7.1% |
| l | 1201582 | 6.9% |
| t | 962888 | 5.5% |
| r | 820300 | 4.7% |
| m | 757930 | 4.3% |
| Other values (16) | 4447723 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17521322 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2004700 | |
| e | 1667454 | 9.5% |
| n | 1557938 | 8.9% |
| o | 1491572 | 8.5% |
| s | 1357311 | 7.7% |
| i | 1251924 | 7.1% |
| l | 1201582 | 6.9% |
| t | 962888 | 5.5% |
| r | 820300 | 4.7% |
| m | 757930 | 4.3% |
| Other values (16) | 4447723 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17521322 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2004700 | |
| e | 1667454 | 9.5% |
| n | 1557938 | 8.9% |
| o | 1491572 | 8.5% |
| s | 1357311 | 7.7% |
| i | 1251924 | 7.1% |
| l | 1201582 | 6.9% |
| t | 962888 | 5.5% |
| r | 820300 | 4.7% |
| m | 757930 | 4.3% |
| Other values (16) | 4447723 |
price
Real number (ℝ)
High correlation 
| Distinct | 10765 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10589.42 |
| Minimum | 255 |
|---|---|
| Maximum | 74999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | 255 |
|---|---|
| 5-th percentile | 1995 |
| Q1 | 4250 |
| median | 7000 |
| Q3 | 13000 |
| 95-th percentile | 31500 |
| Maximum | 74999 |
| Range | 74744 |
| Interquartile range (IQR) | 8750 |
Descriptive statistics
| Standard deviation | 10235.364 |
|---|---|
| Coefficient of variation (CV) | 0.96656514 |
| Kurtosis | 7.7353662 |
| Mean | 10589.42 |
| Median Absolute Deviation (MAD) | 3500 |
| Skewness | 2.4679172 |
| Sum | 2.4254261 × 1010 |
| Variance | 1.0476267 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4500 | 52927 | 2.3% |
| 3500 | 52178 | 2.3% |
| 5500 | 49669 | 2.2% |
| 6500 | 49295 | 2.2% |
| 5000 | 42324 | 1.8% |
| 7500 | 42297 | 1.8% |
| 2500 | 40796 | 1.8% |
| 8500 | 36915 | 1.6% |
| 4000 | 36896 | 1.6% |
| 3000 | 36063 | 1.6% |
| Other values (10755) | 1851064 |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 259 | 11 | < 0.1% |
| 260 | 3 | < 0.1% |
| 265 | 2 | < 0.1% |
| 269 | 3 | < 0.1% |
| 270 | 1 | < 0.1% |
| 275 | 29 | |
| 277 | 1 | < 0.1% |
| 279 | 1 | < 0.1% |
| 280 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 74999 | 98 | |
| 74998 | 3 | < 0.1% |
| 74995 | 31 | < 0.1% |
| 74990 | 5 | < 0.1% |
| 74985 | 1 | < 0.1% |
| 74980 | 1 | < 0.1% |
| 74950 | 16 | < 0.1% |
| 74910 | 1 | < 0.1% |
| 74900 | 110 | |
| 74888 | 1 | < 0.1% |
odometer
Real number (ℝ)
High correlation 
| Distinct | 179879 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133452.78 |
| Minimum | 1001 |
|---|---|
| Maximum | 399999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 30551.15 |
| Q1 | 89789 |
| median | 131000 |
| Q3 | 174000 |
| 95-th percentile | 242150 |
| Maximum | 399999 |
| Range | 398998 |
| Interquartile range (IQR) | 84211 |
Descriptive statistics
| Standard deviation | 63758.95 |
|---|---|
| Coefficient of variation (CV) | 0.47776412 |
| Kurtosis | 0.27523691 |
| Mean | 133452.78 |
| Median Absolute Deviation (MAD) | 42000 |
| Skewness | 0.3818283 |
| Sum | 3.0566345 × 1011 |
| Variance | 4.0652037 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200000 | 36830 | 1.6% |
| 150000 | 30157 | 1.3% |
| 160000 | 27103 | 1.2% |
| 140000 | 25492 | 1.1% |
| 180000 | 24918 | 1.1% |
| 170000 | 24282 | 1.1% |
| 130000 | 23842 | 1.0% |
| 120000 | 21534 | 0.9% |
| 100000 | 18619 | 0.8% |
| 190000 | 18199 | 0.8% |
| Other values (179869) | 2039448 |
| Value | Count | Frequency (%) |
| 1001 | 6 | |
| 1003 | 2 | < 0.1% |
| 1004 | 4 | < 0.1% |
| 1005 | 3 | < 0.1% |
| 1006 | 5 | |
| 1007 | 3 | < 0.1% |
| 1008 | 9 | |
| 1009 | 3 | < 0.1% |
| 1010 | 10 | |
| 1012 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 399999 | 4 | |
| 399990 | 1 | < 0.1% |
| 399896 | 1 | < 0.1% |
| 399842 | 1 | < 0.1% |
| 399788 | 1 | < 0.1% |
| 399700 | 1 | < 0.1% |
| 399699 | 1 | < 0.1% |
| 399695 | 1 | < 0.1% |
| 399600 | 1 | < 0.1% |
| 399559 | 1 | < 0.1% |
year
Real number (ℝ)
High correlation 
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2008.2009 |
| Minimum | 1974 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | 1974 |
|---|---|
| 5-th percentile | 1993 |
| Q1 | 2004 |
| median | 2009 |
| Q3 | 2014 |
| 95-th percentile | 2019 |
| Maximum | 2025 |
| Range | 51 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.3771385 |
|---|---|
| Coefficient of variation (CV) | 0.0041714645 |
| Kurtosis | 1.9719509 |
| Mean | 2008.2009 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -1.0987996 |
| Sum | 4.5996314 × 109 |
| Variance | 70.17645 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 130674 | 5.7% |
| 2008 | 128567 | 5.6% |
| 2007 | 127225 | 5.6% |
| 2012 | 126240 | 5.5% |
| 2014 | 120326 | 5.3% |
| 2006 | 117439 | 5.1% |
| 2011 | 115067 | 5.0% |
| 2015 | 110476 | 4.8% |
| 2010 | 104005 | 4.5% |
| 2005 | 101884 | 4.4% |
| Other values (42) | 1108521 |
| Value | Count | Frequency (%) |
| 1974 | 4221 | |
| 1975 | 2951 | |
| 1976 | 4042 | |
| 1977 | 4653 | |
| 1978 | 5202 | |
| 1979 | 5979 | |
| 1980 | 3472 | |
| 1981 | 2949 | |
| 1982 | 3375 | |
| 1983 | 3689 |
| Value | Count | Frequency (%) |
| 2025 | 240 | < 0.1% |
| 2024 | 4941 | 0.2% |
| 2023 | 15980 | 0.7% |
| 2022 | 23683 | 1.0% |
| 2021 | 31404 | 1.4% |
| 2020 | 37022 | 1.6% |
| 2019 | 52737 | |
| 2018 | 64096 | |
| 2017 | 81557 | |
| 2016 | 93361 |
long
Real number (ℝ)
| Distinct | 306755 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 136 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -100.61135 |
| Minimum | -177.00763 |
|---|---|
| Maximum | 142.12326 |
| Zeros | 1846 |
| Zeros (%) | 0.1% |
| Negative | 2288416 |
| Negative (%) | 99.9% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | -177.00763 |
|---|---|
| 5-th percentile | -122.6801 |
| Q1 | -118.3507 |
| median | -97.9122 |
| Q3 | -80.9288 |
| 95-th percentile | -73.709983 |
| Maximum | 142.12326 |
| Range | 319.13089 |
| Interquartile range (IQR) | 37.4219 |
Descriptive statistics
| Standard deviation | 19.928225 |
|---|---|
| Coefficient of variation (CV) | -0.19807134 |
| Kurtosis | -0.18559081 |
| Mean | -100.61135 |
| Median Absolute Deviation (MAD) | 18.4498 |
| Skewness | -0.12791197 |
| Sum | -2.3042896 × 108 |
| Variance | 397.13414 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -80.2926 | 5319 | 0.2% |
| -80.2264 | 5166 | 0.2% |
| -80.1407 | 3886 | 0.2% |
| -80.3165 | 3618 | 0.2% |
| -80.1157 | 3094 | 0.1% |
| -80.403 | 2943 | 0.1% |
| -80.4085 | 2652 | 0.1% |
| -80.1891 | 2583 | 0.1% |
| -80.2153 | 2566 | 0.1% |
| -80.2092 | 2491 | 0.1% |
| Other values (306745) | 2255970 |
| Value | Count | Frequency (%) |
| -177.007631 | 1 | < 0.1% |
| -175.869141 | 1 | < 0.1% |
| -166.538642 | 1 | < 0.1% |
| -166.1151 | 1 | < 0.1% |
| -165.961268 | 1 | < 0.1% |
| -162.7211 | 1 | < 0.1% |
| -162.685547 | 1 | < 0.1% |
| -161.990162 | 3 | |
| -161.8749 | 2 | |
| -159.8251 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 142.12326 | 1 | < 0.1% |
| 139.6917 | 2 | |
| 139.3485 | 1 | < 0.1% |
| 136.8326 | 1 | < 0.1% |
| 128.838981 | 1 | < 0.1% |
| 127.7586 | 2 | |
| 127.0706 | 2 | |
| 126.9775 | 1 | < 0.1% |
| 126.92395 | 4 | |
| 120.5833 | 1 | < 0.1% |
lat
Real number (ℝ)
| Distinct | 306497 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 136 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.578113 |
| Minimum | -82.921058 |
|---|---|
| Maximum | 142.58258 |
| Zeros | 1852 |
| Zeros (%) | 0.1% |
| Negative | 231 |
| Negative (%) | < 0.1% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | -82.921058 |
|---|---|
| 5-th percentile | 25.983891 |
| Q1 | 33.1101 |
| median | 36.963687 |
| Q3 | 40.964616 |
| 95-th percentile | 46.871 |
| Maximum | 142.58258 |
| Range | 225.50363 |
| Interquartile range (IQR) | 7.8545162 |
Descriptive statistics
| Standard deviation | 6.5174326 |
|---|---|
| Coefficient of variation (CV) | 0.17817848 |
| Kurtosis | 2.9795332 |
| Mean | 36.578113 |
| Median Absolute Deviation (MAD) | 3.9343865 |
| Skewness | -0.29118532 |
| Sum | 83774412 |
| Variance | 42.476928 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25.8301 | 5319 | 0.2% |
| 26.1122 | 5171 | 0.2% |
| 26.0218 | 4218 | 0.2% |
| 25.985 | 3841 | 0.2% |
| 26.2785 | 3094 | 0.1% |
| 26.152 | 2865 | 0.1% |
| 25.6694 | 2652 | 0.1% |
| 25.9894 | 2554 | 0.1% |
| 26.2674 | 2487 | 0.1% |
| 27.3215 | 2263 | 0.1% |
| Other values (306487) | 2255824 |
| Value | Count | Frequency (%) |
| -82.921058 | 1 | |
| -80.172912 | 1 | |
| -75.747631 | 1 | |
| -67.980238 | 1 | |
| -66.787821 | 1 | |
| -62.712724 | 1 | |
| -62.428643 | 1 | |
| -62.383597 | 1 | |
| -60.319107 | 1 | |
| -55.379769 | 1 |
| Value | Count | Frequency (%) |
| 142.582577 | 1 | < 0.1% |
| 71.683788 | 1 | < 0.1% |
| 71.41821 | 1 | < 0.1% |
| 66.742308 | 1 | < 0.1% |
| 66.5656 | 1 | < 0.1% |
| 65.168 | 1 | < 0.1% |
| 65.0907 | 1 | < 0.1% |
| 65.07 | 17 | |
| 65.002647 | 1 | < 0.1% |
| 64.999013 | 1 | < 0.1% |
make
Text
Missing 
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 47044 |
| Missing (%) | 2.1% |
| Memory size | 118.8 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 5.8706425 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | freightliner |
|---|---|
| 2nd row | buick |
| 3rd row | chevrolet |
| 4th row | pontiac |
| 5th row | audi |
| Value | Count | Frequency (%) |
| ford | 343923 | |
| toyota | 260562 | 11.5% |
| chevrolet | 256525 | 11.4% |
| honda | 161340 | 7.2% |
| nissan | 129465 | 5.7% |
| jeep | 92190 | 4.1% |
| bmw | 84250 | 3.7% |
| mercedes-benz | 69607 | 3.1% |
| gmc | 68722 | 3.0% |
| ram | 68650 | 3.0% |
| Other values (58) | 720945 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1508165 | 11.5% |
| e | 1243755 | 9.4% |
| a | 1126233 | 8.6% |
| r | 981529 | 7.5% |
| t | 861336 | 6.5% |
| d | 859238 | 6.5% |
| n | 737347 | 5.6% |
| s | 621338 | 4.7% |
| c | 594419 | 4.5% |
| l | 539122 | 4.1% |
| Other values (17) | 4097600 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13170082 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 1508165 | 11.5% |
| e | 1243755 | 9.4% |
| a | 1126233 | 8.6% |
| r | 981529 | 7.5% |
| t | 861336 | 6.5% |
| d | 859238 | 6.5% |
| n | 737347 | 5.6% |
| s | 621338 | 4.7% |
| c | 594419 | 4.5% |
| l | 539122 | 4.1% |
| Other values (17) | 4097600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13170082 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 1508165 | 11.5% |
| e | 1243755 | 9.4% |
| a | 1126233 | 8.6% |
| r | 981529 | 7.5% |
| t | 861336 | 6.5% |
| d | 859238 | 6.5% |
| n | 737347 | 5.6% |
| s | 621338 | 4.7% |
| c | 594419 | 4.5% |
| l | 539122 | 4.1% |
| Other values (17) | 4097600 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13170082 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 1508165 | 11.5% |
| e | 1243755 | 9.4% |
| a | 1126233 | 8.6% |
| r | 981529 | 7.5% |
| t | 861336 | 6.5% |
| d | 859238 | 6.5% |
| n | 737347 | 5.6% |
| s | 621338 | 4.7% |
| c | 594419 | 4.5% |
| l | 539122 | 4.1% |
| Other values (17) | 4097600 |
title
Categorical
Imbalance 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 118.3 MiB |
| clean | |
|---|---|
| rebuilt | 103170 |
| salvage | 77702 |
| lien | 20006 |
| missing | 6687 |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 5.1592312 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | clean |
|---|---|
| 2nd row | clean |
| 3rd row | rebuilt |
| 4th row | clean |
| 5th row | clean |
Common Values
| Value | Count | Frequency (%) |
| clean | 2080940 | |
| rebuilt | 103170 | 4.5% |
| salvage | 77702 | 3.4% |
| lien | 20006 | 0.9% |
| missing | 6687 | 0.3% |
| parts only | 1919 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| clean | 2080940 | |
| rebuilt | 103170 | 4.5% |
| salvage | 77702 | 3.4% |
| lien | 20006 | 0.9% |
| missing | 6687 | 0.3% |
| parts | 1919 | 0.1% |
| only | 1919 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 2283737 | |
| e | 2281818 | |
| a | 2238263 | |
| n | 2109552 | |
| c | 2080940 | |
| i | 136550 | 1.2% |
| t | 105089 | 0.9% |
| r | 105089 | 0.9% |
| u | 103170 | 0.9% |
| b | 103170 | 0.9% |
| Other values (8) | 269449 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11816827 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 2283737 | |
| e | 2281818 | |
| a | 2238263 | |
| n | 2109552 | |
| c | 2080940 | |
| i | 136550 | 1.2% |
| t | 105089 | 0.9% |
| r | 105089 | 0.9% |
| u | 103170 | 0.9% |
| b | 103170 | 0.9% |
| Other values (8) | 269449 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11816827 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 2283737 | |
| e | 2281818 | |
| a | 2238263 | |
| n | 2109552 | |
| c | 2080940 | |
| i | 136550 | 1.2% |
| t | 105089 | 0.9% |
| r | 105089 | 0.9% |
| u | 103170 | 0.9% |
| b | 103170 | 0.9% |
| Other values (8) | 269449 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11816827 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 2283737 | |
| e | 2281818 | |
| a | 2238263 | |
| n | 2109552 | |
| c | 2080940 | |
| i | 136550 | 1.2% |
| t | 105089 | 0.9% |
| r | 105089 | 0.9% |
| u | 103170 | 0.9% |
| b | 103170 | 0.9% |
| Other values (8) | 269449 | 2.3% |
predicted_price
Real number (ℝ)
High correlation  Missing 
| Distinct | 881482 |
|---|---|
| Distinct (%) | 51.5% |
| Missing | 577806 |
| Missing (%) | 25.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9636.5497 |
| Minimum | -121819.73 |
|---|---|
| Maximum | 175218.63 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 34034 |
| Negative (%) | 1.5% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | -121819.73 |
|---|---|
| 5-th percentile | 1318.9146 |
| Q1 | 3974.4492 |
| median | 6950.429 |
| Q3 | 12119.948 |
| 95-th percentile | 27921.64 |
| Maximum | 175218.63 |
| Range | 297038.36 |
| Interquartile range (IQR) | 8145.4984 |
Descriptive statistics
| Standard deviation | 9228.5677 |
|---|---|
| Coefficient of variation (CV) | 0.95766306 |
| Kurtosis | 10.302222 |
| Mean | 9636.5497 |
| Median Absolute Deviation (MAD) | 3584.9327 |
| Skewness | 2.5019846 |
| Sum | 1.6503729 × 1010 |
| Variance | 85166462 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5963.142062 | 365 | < 0.1% |
| 5206.482999 | 325 | < 0.1% |
| 12464.03675 | 310 | < 0.1% |
| 5614.342006 | 215 | < 0.1% |
| 4978.933092 | 185 | < 0.1% |
| 7479.966291 | 177 | < 0.1% |
| 6482.27056 | 165 | < 0.1% |
| 28340.80192 | 165 | < 0.1% |
| 15873.14682 | 163 | < 0.1% |
| 7034.002231 | 155 | < 0.1% |
| Other values (881472) | 1710393 | |
| (Missing) | 577806 | 25.2% |
| Value | Count | Frequency (%) |
| -121819.73 | 1 | < 0.1% |
| -112894.7437 | 2 | < 0.1% |
| -110346.7735 | 1 | < 0.1% |
| -87851.72981 | 1 | < 0.1% |
| -79342.24351 | 1 | < 0.1% |
| -79129.65846 | 1 | < 0.1% |
| -76550.57958 | 5 | |
| -70779.46514 | 1 | < 0.1% |
| -68658.36891 | 1 | < 0.1% |
| -68222.09689 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 175218.6349 | 1 | |
| 174149.3679 | 1 | |
| 166346.281 | 1 | |
| 163898.331 | 1 | |
| 145138.8127 | 1 | |
| 137544.701 | 1 | |
| 136504.9896 | 1 | |
| 135853.7222 | 1 | |
| 132849.0895 | 1 | |
| 132441.7556 | 1 |
residual
Real number (ℝ)
Missing 
| Distinct | 1250957 |
|---|---|
| Distinct (%) | 73.0% |
| Missing | 577806 |
| Missing (%) | 25.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 930.84842 |
| Minimum | -173528.63 |
|---|---|
| Maximum | 145629.66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 701065 |
| Negative (%) | 30.6% |
| Memory size | 17.5 MiB |
Quantile statistics
| Minimum | -173528.63 |
|---|---|
| 5-th percentile | -5636.294 |
| Q1 | -1118.6769 |
| median | 542.07632 |
| Q3 | 2474.398 |
| 95-th percentile | 9099.9732 |
| Maximum | 145629.66 |
| Range | 319158.29 |
| Interquartile range (IQR) | 3593.0749 |
Descriptive statistics
| Standard deviation | 5451.9053 |
|---|---|
| Coefficient of variation (CV) | 5.8569207 |
| Kurtosis | 23.218567 |
| Mean | 930.84842 |
| Median Absolute Deviation (MAD) | 1781.6379 |
| Skewness | 0.64006142 |
| Sum | 1.5941878 × 109 |
| Variance | 29723272 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16035.96325 | 306 | < 0.1% |
| 1420.033709 | 175 | < 0.1% |
| 526.8579378 | 170 | < 0.1% |
| 93.517001 | 165 | < 0.1% |
| 1026.853182 | 160 | < 0.1% |
| -13208.73135 | 140 | < 0.1% |
| 430.6721447 | 135 | < 0.1% |
| -502.4700821 | 135 | < 0.1% |
| 1902.713124 | 132 | < 0.1% |
| -7724.816742 | 125 | < 0.1% |
| Other values (1250947) | 1710975 | |
| (Missing) | 577806 | 25.2% |
| Value | Count | Frequency (%) |
| -173528.6349 | 1 | |
| -172649.3679 | 1 | |
| -143448.8127 | 1 | |
| -129441.7556 | 1 | |
| -117888.2509 | 1 | |
| -116762.4411 | 1 | |
| -105853.7222 | 1 | |
| -99356.95753 | 1 | |
| -97346.28101 | 1 | |
| -96898.33099 | 1 |
| Value | Count | Frequency (%) |
| 145629.6585 | 1 | < 0.1% |
| 127894.7437 | 2 | < 0.1% |
| 123819.73 | 1 | < 0.1% |
| 113050.5796 | 5 | |
| 111096.7735 | 1 | < 0.1% |
| 105351.7298 | 1 | < 0.1% |
| 97458.36891 | 1 | < 0.1% |
| 97068.20604 | 1 | < 0.1% |
| 91842.24351 | 1 | < 0.1% |
| 81779.46514 | 1 | < 0.1% |
time_posted
Date
| Distinct | 1856420 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.5 MiB |
| Minimum | 2023-12-03 08:00:27+00:00 |
|---|---|
| Maximum | 2024-12-01 20:08:47+00:00 |
condition
Categorical
Missing 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 369671 |
| Missing (%) | 16.1% |
| Memory size | 121.6 MiB |
| excellent | |
|---|---|
| good | |
| like new | |
| fair | |
| salvage | 13279 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.5968477 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | good |
|---|---|
| 2nd row | excellent |
| 3rd row | like new |
| 4th row | excellent |
| 5th row | good |
Common Values
| Value | Count | Frequency (%) |
| excellent | 806283 | |
| good | 713692 | |
| like new | 232055 | 10.1% |
| fair | 143875 | 6.3% |
| salvage | 13279 | 0.6% |
| new | 11569 | 0.5% |
| (Missing) | 369671 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| excellent | 806283 | |
| good | 713692 | |
| new | 243624 | 11.3% |
| like | 232055 | 10.8% |
| fair | 143875 | 6.7% |
| salvage | 13279 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2907807 | |
| l | 1857900 | |
| o | 1427384 | |
| n | 1049907 | 8.3% |
| x | 806283 | 6.4% |
| c | 806283 | 6.4% |
| t | 806283 | 6.4% |
| g | 726971 | 5.7% |
| d | 713692 | 5.6% |
| i | 375930 | 3.0% |
| Other values (8) | 1192475 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12670915 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2907807 | |
| l | 1857900 | |
| o | 1427384 | |
| n | 1049907 | 8.3% |
| x | 806283 | 6.4% |
| c | 806283 | 6.4% |
| t | 806283 | 6.4% |
| g | 726971 | 5.7% |
| d | 713692 | 5.6% |
| i | 375930 | 3.0% |
| Other values (8) | 1192475 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12670915 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2907807 | |
| l | 1857900 | |
| o | 1427384 | |
| n | 1049907 | 8.3% |
| x | 806283 | 6.4% |
| c | 806283 | 6.4% |
| t | 806283 | 6.4% |
| g | 726971 | 5.7% |
| d | 713692 | 5.6% |
| i | 375930 | 3.0% |
| Other values (8) | 1192475 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12670915 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2907807 | |
| l | 1857900 | |
| o | 1427384 | |
| n | 1049907 | 8.3% |
| x | 806283 | 6.4% |
| c | 806283 | 6.4% |
| t | 806283 | 6.4% |
| g | 726971 | 5.7% |
| d | 713692 | 5.6% |
| i | 375930 | 3.0% |
| Other values (8) | 1192475 |
url
URL
| Distinct | 1998952 |
|---|---|
| Distinct (%) | 87.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 297.4 MiB |
| https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 |
|---|---|
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 |
| https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 |
| https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 |
| Other values (1998947) |
| Value | Count | Frequency (%) |
| https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html | 90 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | 85 | < 0.1% |
| https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | 85 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | 85 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html | 80 | < 0.1% |
| Other values (1998942) | 2289514 |
| Value | Count | Frequency (%) |
| https | 2290424 |
| Value | Count | Frequency (%) |
| miami.craigslist.org | 203815 | 8.9% |
| sfbay.craigslist.org | 142970 | 6.2% |
| losangeles.craigslist.org | 104976 | 4.6% |
| phoenix.craigslist.org | 93184 | 4.1% |
| portland.craigslist.org | 65886 | 2.9% |
| seattle.craigslist.org | 65580 | 2.9% |
| sandiego.craigslist.org | 61539 | 2.7% |
| sacramento.craigslist.org | 57269 | 2.5% |
| orangecounty.craigslist.org | 51898 | 2.3% |
| dallas.craigslist.org | 48703 | 2.1% |
| Other values (405) | 1394604 |
| Value | Count | Frequency (%) |
| /mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 | < 0.1% |
| /pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 | < 0.1% |
| /pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 | < 0.1% |
| /pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 | < 0.1% |
| /mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 | < 0.1% |
| /mdc/cto/d/miami-2011-ford-mustang/7760134705.html | 90 | < 0.1% |
| /pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | 85 | < 0.1% |
| /brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | 85 | < 0.1% |
| /mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | 85 | < 0.1% |
| /mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html | 80 | < 0.1% |
| Other values (1998942) | 2289514 |
| Value | Count | Frequency (%) |
| 2290424 |
| Value | Count | Frequency (%) |
| 2290424 |
state
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 125.5 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4478939 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Florida |
|---|---|
| 2nd row | Georgia |
| 3rd row | South Dakota |
| 4th row | Nevada |
| 5th row | Texas |
| Value | Count | Frequency (%) |
| california | 542610 | |
| florida | 295453 | 11.4% |
| new | 177884 | 6.9% |
| texas | 152277 | 5.9% |
| arizona | 128754 | 5.0% |
| washington | 104607 | 4.0% |
| oregon | 102795 | 4.0% |
| york | 95515 | 3.7% |
| colorado | 76948 | 3.0% |
| carolina | 59556 | 2.3% |
| Other values (45) | 853078 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2683483 | |
| i | 2413530 | |
| o | 2010117 | |
| n | 1582668 | 8.2% |
| r | 1552795 | 8.0% |
| l | 1172578 | 6.1% |
| e | 902435 | 4.7% |
| s | 802271 | 4.1% |
| C | 718589 | 3.7% |
| f | 565667 | 2.9% |
| Other values (36) | 4945126 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19349259 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2683483 | |
| i | 2413530 | |
| o | 2010117 | |
| n | 1582668 | 8.2% |
| r | 1552795 | 8.0% |
| l | 1172578 | 6.1% |
| e | 902435 | 4.7% |
| s | 802271 | 4.1% |
| C | 718589 | 3.7% |
| f | 565667 | 2.9% |
| Other values (36) | 4945126 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19349259 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2683483 | |
| i | 2413530 | |
| o | 2010117 | |
| n | 1582668 | 8.2% |
| r | 1552795 | 8.0% |
| l | 1172578 | 6.1% |
| e | 902435 | 4.7% |
| s | 802271 | 4.1% |
| C | 718589 | 3.7% |
| f | 565667 | 2.9% |
| Other values (36) | 4945126 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19349259 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2683483 | |
| i | 2413530 | |
| o | 2010117 | |
| n | 1582668 | 8.2% |
| r | 1552795 | 8.0% |
| l | 1172578 | 6.1% |
| e | 902435 | 4.7% |
| s | 802271 | 4.1% |
| C | 718589 | 3.7% |
| f | 565667 | 2.9% |
| Other values (36) | 4945126 |
model
Text
Missing 
| Distinct | 1287 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 192028 |
| Missing (%) | 8.4% |
| Memory size | 115.2 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 26 |
| Mean length | 5.6316782 |
| Min length | 1 |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | sprinter 2500 |
|---|---|
| 2nd row | encore |
| 3rd row | colorado |
| 4th row | solstice |
| 5th row | q5 |
| Value | Count | Frequency (%) |
| 1500 | 72009 | 3.2% |
| f150 | 69513 | 3.1% |
| silverado | 53250 | 2.3% |
| camry | 45510 | 2.0% |
| accord | 44643 | 2.0% |
| r | 41880 | 1.8% |
| 2500 | 41112 | 1.8% |
| civic | 39560 | 1.7% |
| wrangler | 38069 | 1.7% |
| f250 | 31990 | 1.4% |
| Other values (940) | 1789701 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1197265 | 10.1% |
| r | 1162904 | 9.8% |
| e | 1025594 | 8.7% |
| o | 740805 | 6.3% |
| c | 683820 | 5.8% |
| t | 610484 | 5.2% |
| s | 601543 | 5.1% |
| i | 570802 | 4.8% |
| n | 560962 | 4.7% |
| 0 | 512209 | 4.3% |
| Other values (33) | 4151103 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11817491 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1197265 | 10.1% |
| r | 1162904 | 9.8% |
| e | 1025594 | 8.7% |
| o | 740805 | 6.3% |
| c | 683820 | 5.8% |
| t | 610484 | 5.2% |
| s | 601543 | 5.1% |
| i | 570802 | 4.8% |
| n | 560962 | 4.7% |
| 0 | 512209 | 4.3% |
| Other values (33) | 4151103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11817491 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1197265 | 10.1% |
| r | 1162904 | 9.8% |
| e | 1025594 | 8.7% |
| o | 740805 | 6.3% |
| c | 683820 | 5.8% |
| t | 610484 | 5.2% |
| s | 601543 | 5.1% |
| i | 570802 | 4.8% |
| n | 560962 | 4.7% |
| 0 | 512209 | 4.3% |
| Other values (33) | 4151103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11817491 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1197265 | 10.1% |
| r | 1162904 | 9.8% |
| e | 1025594 | 8.7% |
| o | 740805 | 6.3% |
| c | 683820 | 5.8% |
| t | 610484 | 5.2% |
| s | 601543 | 5.1% |
| i | 570802 | 4.8% |
| n | 560962 | 4.7% |
| 0 | 512209 | 4.3% |
| Other values (33) | 4151103 |
paint
Categorical
Missing 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 623480 |
| Missing (%) | 27.2% |
| Memory size | 118.8 MiB |
| white | |
|---|---|
| black | |
| silver | |
| grey | |
| blue | |
| Other values (7) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.7566985 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | white |
|---|---|
| 2nd row | red |
| 3rd row | brown |
| 4th row | green |
| 5th row | custom |
Common Values
| Value | Count | Frequency (%) |
| white | 409252 | |
| black | 290438 | |
| silver | 238523 | 10.4% |
| grey | 215967 | 9.4% |
| blue | 179710 | 7.8% |
| red | 157710 | 6.9% |
| green | 60055 | 2.6% |
| brown | 48285 | 2.1% |
| custom | 36398 | 1.6% |
| yellow | 15178 | 0.7% |
| Other values (2) | 15428 | 0.7% |
| (Missing) | 623480 |
Length
| Value | Count | Frequency (%) |
| white | 409252 | |
| black | 290438 | |
| silver | 238523 | |
| grey | 215967 | |
| blue | 179710 | |
| red | 157710 | 9.5% |
| green | 60055 | 3.6% |
| brown | 48285 | 2.9% |
| custom | 36398 | 2.2% |
| yellow | 15178 | 0.9% |
| Other values (2) | 15428 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1351878 | |
| l | 744883 | 9.4% |
| r | 735968 | 9.3% |
| i | 647775 | 8.2% |
| b | 518433 | 6.5% |
| w | 472715 | 6.0% |
| t | 445650 | 5.6% |
| h | 409252 | 5.2% |
| c | 326836 | 4.1% |
| a | 300010 | 3.8% |
| Other values (11) | 1975750 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7929150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1351878 | |
| l | 744883 | 9.4% |
| r | 735968 | 9.3% |
| i | 647775 | 8.2% |
| b | 518433 | 6.5% |
| w | 472715 | 6.0% |
| t | 445650 | 5.6% |
| h | 409252 | 5.2% |
| c | 326836 | 4.1% |
| a | 300010 | 3.8% |
| Other values (11) | 1975750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7929150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1351878 | |
| l | 744883 | 9.4% |
| r | 735968 | 9.3% |
| i | 647775 | 8.2% |
| b | 518433 | 6.5% |
| w | 472715 | 6.0% |
| t | 445650 | 5.6% |
| h | 409252 | 5.2% |
| c | 326836 | 4.1% |
| a | 300010 | 3.8% |
| Other values (11) | 1975750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7929150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1351878 | |
| l | 744883 | 9.4% |
| r | 735968 | 9.3% |
| i | 647775 | 8.2% |
| b | 518433 | 6.5% |
| w | 472715 | 6.0% |
| t | 445650 | 5.6% |
| h | 409252 | 5.2% |
| c | 326836 | 4.1% |
| a | 300010 | 3.8% |
| Other values (11) | 1975750 |
fuel
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12 |
| Missing (%) | < 0.1% |
| Memory size | 114.2 MiB |
| gas | |
|---|---|
| diesel | 129600 |
| hybrid | 50482 |
| electric | 21067 |
| other | 5544 |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.2867034 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | diesel |
|---|---|
| 2nd row | gas |
| 3rd row | gas |
| 4th row | gas |
| 5th row | gas |
Common Values
| Value | Count | Frequency (%) |
| gas | 2083719 | |
| diesel | 129600 | 5.7% |
| hybrid | 50482 | 2.2% |
| electric | 21067 | 0.9% |
| other | 5544 | 0.2% |
| (Missing) | 12 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| gas | 2083719 | |
| diesel | 129600 | 5.7% |
| hybrid | 50482 | 2.2% |
| electric | 21067 | 0.9% |
| other | 5544 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 2213319 | |
| g | 2083719 | |
| a | 2083719 | |
| e | 306878 | 4.1% |
| i | 201149 | 2.7% |
| d | 180082 | 2.4% |
| l | 150667 | 2.0% |
| r | 77093 | 1.0% |
| h | 56026 | 0.7% |
| y | 50482 | 0.7% |
| Other values (4) | 124771 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7527905 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 2213319 | |
| g | 2083719 | |
| a | 2083719 | |
| e | 306878 | 4.1% |
| i | 201149 | 2.7% |
| d | 180082 | 2.4% |
| l | 150667 | 2.0% |
| r | 77093 | 1.0% |
| h | 56026 | 0.7% |
| y | 50482 | 0.7% |
| Other values (4) | 124771 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7527905 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 2213319 | |
| g | 2083719 | |
| a | 2083719 | |
| e | 306878 | 4.1% |
| i | 201149 | 2.7% |
| d | 180082 | 2.4% |
| l | 150667 | 2.0% |
| r | 77093 | 1.0% |
| h | 56026 | 0.7% |
| y | 50482 | 0.7% |
| Other values (4) | 124771 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7527905 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 2213319 | |
| g | 2083719 | |
| a | 2083719 | |
| e | 306878 | 4.1% |
| i | 201149 | 2.7% |
| d | 180082 | 2.4% |
| l | 150667 | 2.0% |
| r | 77093 | 1.0% |
| h | 56026 | 0.7% |
| y | 50482 | 0.7% |
| Other values (4) | 124771 | 1.7% |
drive
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 672749 |
| Missing (%) | 29.4% |
| Memory size | 116.2 MiB |
| 4wd | |
|---|---|
| fwd | |
| rwd |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | fwd |
|---|---|
| 2nd row | 4wd |
| 3rd row | 4wd |
| 4th row | 4wd |
| 5th row | fwd |
Common Values
| Value | Count | Frequency (%) |
| 4wd | 643667 | |
| fwd | 572393 | |
| rwd | 401615 | |
| (Missing) | 672749 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4wd | 643667 | |
| fwd | 572393 | |
| rwd | 401615 |
Most occurring characters
| Value | Count | Frequency (%) |
| w | 1617675 | |
| d | 1617675 | |
| 4 | 643667 | 13.3% |
| f | 572393 | 11.8% |
| r | 401615 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4853025 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| w | 1617675 | |
| d | 1617675 | |
| 4 | 643667 | 13.3% |
| f | 572393 | 11.8% |
| r | 401615 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4853025 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| w | 1617675 | |
| d | 1617675 | |
| 4 | 643667 | 13.3% |
| f | 572393 | 11.8% |
| r | 401615 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4853025 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| w | 1617675 | |
| d | 1617675 | |
| 4 | 643667 | 13.3% |
| f | 572393 | 11.8% |
| r | 401615 | 8.3% |
type
Categorical
High correlation  Missing 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 434032 |
| Missing (%) | 18.9% |
| Memory size | 118.8 MiB |
| SUV | |
|---|---|
| sedan | |
| pickup | |
| truck | |
| coupe | |
| Other values (9) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 5.0273207 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | van |
|---|---|
| 2nd row | truck |
| 3rd row | SUV |
| 4th row | SUV |
| 5th row | SUV |
Common Values
| Value | Count | Frequency (%) |
| SUV | 502396 | |
| sedan | 502343 | |
| pickup | 236256 | |
| truck | 150495 | 6.6% |
| coupe | 101984 | 4.5% |
| hatchback | 100873 | 4.4% |
| convertible | 72582 | 3.2% |
| van | 70396 | 3.1% |
| minivan | 49180 | 2.1% |
| wagon | 33466 | 1.5% |
| Other values (4) | 36421 | 1.6% |
| (Missing) | 434032 |
Length
| Value | Count | Frequency (%) |
| suv | 502396 | |
| sedan | 502343 | |
| pickup | 236256 | |
| truck | 150495 | 8.1% |
| coupe | 101984 | 5.5% |
| hatchback | 100873 | 5.4% |
| convertible | 72582 | 3.9% |
| van | 70396 | 3.8% |
| minivan | 49180 | 2.6% |
| wagon | 33466 | 1.8% |
| Other values (4) | 36421 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 870503 | 9.3% |
| n | 785851 | 8.4% |
| e | 768343 | 8.2% |
| c | 763063 | 8.2% |
| p | 574496 | 6.2% |
| d | 511363 | 5.5% |
| s | 506540 | 5.4% |
| S | 502396 | 5.4% |
| V | 502396 | 5.4% |
| U | 502396 | 5.4% |
| Other values (15) | 3045331 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9332678 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 870503 | 9.3% |
| n | 785851 | 8.4% |
| e | 768343 | 8.2% |
| c | 763063 | 8.2% |
| p | 574496 | 6.2% |
| d | 511363 | 5.5% |
| s | 506540 | 5.4% |
| S | 502396 | 5.4% |
| V | 502396 | 5.4% |
| U | 502396 | 5.4% |
| Other values (15) | 3045331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9332678 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 870503 | 9.3% |
| n | 785851 | 8.4% |
| e | 768343 | 8.2% |
| c | 763063 | 8.2% |
| p | 574496 | 6.2% |
| d | 511363 | 5.5% |
| s | 506540 | 5.4% |
| S | 502396 | 5.4% |
| V | 502396 | 5.4% |
| U | 502396 | 5.4% |
| Other values (15) | 3045331 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9332678 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 870503 | 9.3% |
| n | 785851 | 8.4% |
| e | 768343 | 8.2% |
| c | 763063 | 8.2% |
| p | 574496 | 6.2% |
| d | 511363 | 5.5% |
| s | 506540 | 5.4% |
| S | 502396 | 5.4% |
| V | 502396 | 5.4% |
| U | 502396 | 5.4% |
| Other values (15) | 3045331 |
transmission
Categorical
Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 126.0 MiB |
| automatic | |
|---|---|
| manual | |
| other | 14478 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6870099 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | automatic |
|---|---|
| 2nd row | automatic |
| 3rd row | automatic |
| 4th row | automatic |
| 5th row | automatic |
Common Values
| Value | Count | Frequency (%) |
| automatic | 2056290 | |
| manual | 219656 | 9.6% |
| other | 14478 | 0.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| automatic | 2056290 | |
| manual | 219656 | 9.6% |
| other | 14478 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4551892 | |
| t | 4127058 | |
| u | 2275946 | |
| m | 2275946 | |
| o | 2070768 | |
| i | 2056290 | |
| c | 2056290 | |
| n | 219656 | 1.1% |
| l | 219656 | 1.1% |
| h | 14478 | 0.1% |
| Other values (2) | 28956 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19896936 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 4551892 | |
| t | 4127058 | |
| u | 2275946 | |
| m | 2275946 | |
| o | 2070768 | |
| i | 2056290 | |
| c | 2056290 | |
| n | 219656 | 1.1% |
| l | 219656 | 1.1% |
| h | 14478 | 0.1% |
| Other values (2) | 28956 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19896936 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 4551892 | |
| t | 4127058 | |
| u | 2275946 | |
| m | 2275946 | |
| o | 2070768 | |
| i | 2056290 | |
| c | 2056290 | |
| n | 219656 | 1.1% |
| l | 219656 | 1.1% |
| h | 14478 | 0.1% |
| Other values (2) | 28956 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19896936 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 4551892 | |
| t | 4127058 | |
| u | 2275946 | |
| m | 2275946 | |
| o | 2070768 | |
| i | 2056290 | |
| c | 2056290 | |
| n | 219656 | 1.1% |
| l | 219656 | 1.1% |
| h | 14478 | 0.1% |
| Other values (2) | 28956 | 0.1% |
Interactions
Correlations
| condition | drive | fuel | lat | long | odometer | paint | predicted_price | price | residual | title | transmission | type | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| condition | 1.000 | 0.015 | 0.046 | 0.042 | 0.029 | 0.206 | 0.037 | 0.130 | 0.199 | 0.055 | 0.107 | 0.048 | 0.054 | 0.196 |
| drive | 0.015 | 1.000 | 0.139 | 0.097 | 0.038 | 0.090 | 0.105 | 0.111 | 0.195 | 0.066 | 0.057 | 0.073 | 0.516 | 0.207 |
| fuel | 0.046 | 0.139 | 1.000 | 0.019 | 0.046 | 0.121 | 0.069 | 0.094 | 0.149 | 0.073 | 0.026 | 0.175 | 0.243 | 0.109 |
| lat | 0.042 | 0.097 | 0.019 | 1.000 | -0.121 | 0.064 | 0.012 | -0.069 | -0.032 | 0.090 | 0.052 | 0.028 | 0.025 | -0.103 |
| long | 0.029 | 0.038 | 0.046 | -0.121 | 1.000 | -0.008 | 0.028 | -0.004 | -0.070 | -0.134 | 0.062 | 0.029 | 0.045 | 0.074 |
| odometer | 0.206 | 0.090 | 0.121 | 0.064 | -0.008 | 1.000 | 0.036 | -0.615 | -0.505 | 0.078 | 0.079 | 0.054 | 0.088 | -0.375 |
| paint | 0.037 | 0.105 | 0.069 | 0.012 | 0.028 | 0.036 | 1.000 | 0.025 | 0.048 | 0.014 | 0.023 | 0.082 | 0.098 | 0.105 |
| predicted_price | 0.130 | 0.111 | 0.094 | -0.069 | -0.004 | -0.615 | 0.025 | 1.000 | 0.820 | -0.160 | 0.045 | 0.032 | 0.058 | 0.577 |
| price | 0.199 | 0.195 | 0.149 | -0.032 | -0.070 | -0.505 | 0.048 | 0.820 | 1.000 | 0.323 | 0.072 | 0.029 | 0.097 | 0.476 |
| residual | 0.055 | 0.066 | 0.073 | 0.090 | -0.134 | 0.078 | 0.014 | -0.160 | 0.323 | 1.000 | 0.024 | 0.028 | 0.041 | -0.034 |
| title | 0.107 | 0.057 | 0.026 | 0.052 | 0.062 | 0.079 | 0.023 | 0.045 | 0.072 | 0.024 | 1.000 | 0.034 | 0.039 | 0.103 |
| transmission | 0.048 | 0.073 | 0.175 | 0.028 | 0.029 | 0.054 | 0.082 | 0.032 | 0.029 | 0.028 | 0.034 | 1.000 | 0.193 | 0.197 |
| type | 0.054 | 0.516 | 0.243 | 0.025 | 0.045 | 0.088 | 0.098 | 0.058 | 0.097 | 0.041 | 0.039 | 0.193 | 1.000 | 0.113 |
| year | 0.196 | 0.207 | 0.109 | -0.103 | 0.074 | -0.375 | 0.105 | 0.577 | 0.476 | -0.034 | 0.103 | 0.197 | 0.113 | 1.000 |
Missing values
Sample
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | orlando | 12800.0 | 260078.0 | 2015.0 | -81.362200 | 28.393200 | freightliner | clean | 10037.289627 | 2762.710373 | 2024-11-28 11:14:15+00:00 | good | https://orlando.craigslist.org/cto/d/orlando-sprinter-van/7805995081.html | Florida | sprinter 2500 | white | diesel | fwd | van | automatic |
| 1 | atlanta | 5500.0 | 116000.0 | 2016.0 | -83.863200 | 34.296600 | buick | clean | NaN | NaN | 2024-11-27 10:04:06+00:00 | None | https://atlanta.craigslist.org/nat/cto/d/gainesville-2016-buick-encore-sport/7805731876.html | Georgia | encore | None | gas | None | None | automatic |
| 2 | siouxfalls | 16800.0 | 81100.0 | 2015.0 | -96.310300 | 43.201400 | chevrolet | rebuilt | 16739.760658 | 60.239342 | 2024-11-27 07:15:17+00:00 | excellent | https://siouxfalls.craigslist.org/cto/d/rock-valley-crew-cab-colorado/7805709785.html | South Dakota | colorado | red | gas | 4wd | truck | automatic |
| 3 | lasvegas | 7900.0 | 89000.0 | 2008.0 | -116.932400 | 33.796700 | pontiac | clean | NaN | NaN | 2024-11-25 14:54:13+00:00 | like new | https://lasvegas.craigslist.org/cto/d/san-jacinto-absolutely-mint-condition/7805324202.html | Nevada | solstice | None | gas | None | None | automatic |
| 4 | dallas | 5950.0 | 138000.0 | 2012.0 | -96.838500 | 32.960000 | audi | clean | 8045.831956 | -2095.831956 | 2024-11-24 13:36:04+00:00 | excellent | https://dallas.craigslist.org/dal/cto/d/addison-2012-audi-q5-loaded-138k-nice/7804985720.html | Texas | q5 | brown | gas | None | SUV | automatic |
| 5 | sfbay | 5900.0 | 129000.0 | 2005.0 | -122.077500 | 37.405600 | volkswagen | clean | 2189.987651 | 3710.012349 | 2024-11-21 11:01:37+00:00 | good | https://sfbay.craigslist.org/sby/cto/d/mountain-view-2005-volkswagen-touareg-v6/7804146640.html | California | touareg | green | gas | 4wd | SUV | automatic |
| 6 | portland | 4650.0 | 204000.0 | 2003.0 | -123.504700 | 45.082600 | nissan | clean | 3604.553845 | 1045.446155 | 2024-11-19 09:30:51+00:00 | excellent | https://portland.craigslist.org/yam/cto/d/willamina-03-nissan-pathfinder-le-4x4/7803524372.html | Oregon | pathfinder | custom | gas | 4wd | SUV | automatic |
| 7 | miami | 900.0 | 100000.0 | 2009.0 | -80.292600 | 25.830100 | dodge | clean | NaN | NaN | 2024-11-07 12:36:31+00:00 | None | https://miami.craigslist.org/mdc/cto/d/hialeah-2009-dodge-durango/7800091321.html | Florida | durango | None | gas | None | SUV | automatic |
| 8 | seattle | 5699.0 | 123000.0 | 2009.0 | -122.443485 | 48.790332 | ford | clean | NaN | NaN | 2024-11-05 14:30:48+00:00 | None | https://seattle.craigslist.org/see/cto/d/bellingham-2009-ford-expedition-4x4/7799628737.html | Washington | expedition | None | gas | None | SUV | automatic |
| 9 | littlerock | 6200.0 | 209085.0 | 2013.0 | -92.210655 | 34.493909 | toyota | clean | 6647.499313 | -447.499313 | 2024-11-05 11:51:33+00:00 | excellent | https://littlerock.craigslist.org/cto/d/woodson-2013-prius-6200-obo/7799536266.html | Arkansas | prius c | red | hybrid | fwd | hatchback | automatic |
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2290414 | sfbay | 6400.0 | 200300.0 | 2004.0 | -121.1529 | 38.6709 | chevrolet | clean | NaN | NaN | 2024-04-18 13:34:02+00:00 | None | https://sfbay.craigslist.org/sfc/cto/d/represa-2004-chevrolet-silverado-v6/7738514683.html | California | silverado 1500 | None | gas | None | None | automatic |
| 2290415 | chicago | 3500.0 | 198000.0 | 2006.0 | -87.8387 | 41.9279 | chevrolet | clean | 5304.407288 | -1804.407288 | 2024-03-08 14:20:05+00:00 | good | https://chicago.craigslist.org/nch/cto/d/river-grove-2006-silverado-owner/7725231018.html | Illinois | silverado 1500 | black | gas | rwd | truck | automatic |
| 2290416 | spacecoast | 4900.0 | 200000.0 | 2007.0 | -80.4030 | 27.3215 | chevrolet | clean | NaN | NaN | 2024-11-04 12:27:33+00:00 | None | https://spacecoast.craigslist.org/cto/d/port-saint-lucie-2007-chevy-silverado/7799235343.html | Florida | silverado 1500 | None | gas | None | pickup | automatic |
| 2290417 | vermont | 6000.0 | 157000.0 | 2009.0 | -71.8510 | 44.4380 | chevrolet | clean | 11220.309546 | -5220.309546 | 2024-09-06 11:00:06+00:00 | excellent | https://vermont.craigslist.org/cto/d/concord-chevorlet-silverado-09/7782320378.html | Vermont | silverado 1500 | blue | gas | None | truck | automatic |
| 2290418 | sfbay | 15900.0 | 74000.0 | 2012.0 | -121.9530 | 37.3492 | chevrolet | clean | 19129.265004 | -3229.265004 | 2024-07-27 11:26:05+00:00 | excellent | https://sfbay.craigslist.org/sby/cto/d/santa-clara-2012-chevrolet-silverado/7770005116.html | California | silverado 1500 | silver | gas | rwd | truck | automatic |
| 2290419 | losangeles | 39000.0 | 32000.0 | 2020.0 | -118.3295 | 33.8708 | chevrolet | clean | NaN | NaN | 2024-08-15 17:04:53+00:00 | None | https://losangeles.craigslist.org/wst/cto/d/torrance-2020-chevrolet-silverado-1500/7775871256.html | California | silverado 1500 | None | gas | None | pickup | automatic |
| 2290420 | sacramento | 4800.0 | 220000.0 | 2003.0 | -120.8517 | 37.5239 | chevrolet | clean | 6532.142742 | -1732.142742 | 2024-10-31 11:48:58+00:00 | excellent | https://sacramento.craigslist.org/cto/d/turlock-2003-chevy-step-side/7798185582.html | California | silverado 1500 | black | gas | rwd | truck | manual |
| 2290421 | losangeles | 17500.0 | 170000.0 | 1992.0 | -118.3254 | 34.1005 | chevrolet | clean | NaN | NaN | 2024-09-12 18:23:49+00:00 | None | https://losangeles.craigslist.org/lac/cto/d/los-angeles-1992-chevy-shortbed-pickup/7784298349.html | California | silverado 1500 | None | gas | None | pickup | automatic |
| 2290422 | poconos | 1500.0 | 160000.0 | 2003.0 | -74.9380 | 41.2400 | chevrolet | clean | NaN | NaN | 2024-04-09 08:00:31+00:00 | None | https://poconos.craigslist.org/cto/d/dingmans-ferry-chevy-silverado/7735510884.html | Pennsylvania | silverado 1500 | None | gas | rwd | None | automatic |
| 2290423 | boone | 30000.0 | 46900.0 | 2019.0 | -81.1573 | 36.1359 | chevrolet | clean | 29318.781895 | 681.218105 | 2024-04-18 19:11:05+00:00 | excellent | https://boone.craigslist.org/cto/d/wilkesboro-2019-silverado-ld-2wd/7738566141.html | North Carolina | silverado 1500 | white | gas | rwd | truck | automatic |
Duplicate rows
Most frequently occurring
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46175 | miami | 20900.0 | 88000.0 | 2018.0 | -80.207000 | 25.851200 | ford | clean | 10834.580605 | 10065.419395 | 2024-07-02 14:44:10+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | Florida | mustang | white | gas | rwd | convertible | automatic | 110 |
| 11953 | miami | 1500.0 | 180000.0 | 2005.0 | -80.142356 | 26.295185 | scion | clean | 2463.666613 | -963.666613 | 2024-06-18 12:29:42+00:00 | fair | https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | Florida | xb | grey | gas | fwd | sedan | automatic | 95 |
| 20925 | miami | 4500.0 | 146683.0 | 2012.0 | -80.056000 | 26.618200 | kia | clean | NaN | NaN | 2024-07-02 13:40:53+00:00 | NaN | https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | Florida | rio | NaN | gas | NaN | sedan | automatic | 95 |
| 33789 | miami | 8500.0 | 154000.0 | 2006.0 | -80.084400 | 26.346200 | gmc | clean | 8067.815536 | 432.184464 | 2024-06-24 13:37:00+00:00 | good | https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | Florida | 1500 | grey | gas | rwd | pickup | automatic | 95 |
| 17416 | miami | 3500.0 | 228000.0 | 2005.0 | -80.358800 | 25.734300 | lexus | clean | 3637.888707 | -137.888707 | 2024-06-28 11:07:17+00:00 | good | https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | Florida | ls | silver | gas | fwd | sedan | automatic | 90 |
| 26002 | miami | 5900.0 | 101000.0 | 2011.0 | -80.404600 | 25.596800 | ford | rebuilt | 10574.741723 | -4674.741723 | 2024-06-24 21:56:57+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html | Florida | mustang | black | gas | rwd | convertible | manual | 90 |
| 13982 | miami | 2500.0 | 220000.0 | 2004.0 | -80.195000 | 26.585000 | bmw | clean | NaN | NaN | 2024-06-08 08:51:23+00:00 | NaN | https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | Florida | 2 | black | gas | NaN | sedan | automatic | 85 |
| 37872 | miami | 10500.0 | 162000.0 | 2015.0 | -80.380900 | 26.100300 | lexus | clean | 8396.419744 | 2103.580256 | 2024-06-23 22:39:29+00:00 | good | https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | Florida | ct | silver | hybrid | NaN | hatchback | automatic | 85 |
| 42685 | miami | 14900.0 | 44000.0 | 2019.0 | -80.418629 | 25.598488 | gmc | rebuilt | 20529.461749 | -5629.461749 | 2024-06-26 12:51:10+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | Florida | acadia | silver | gas | fwd | SUV | automatic | 85 |
| 20077 | miami | 4300.0 | 129000.0 | 2010.0 | -80.121300 | 26.263500 | volkswagen | clean | 5220.294134 | -920.294134 | 2024-06-24 21:33:50+00:00 | excellent | https://miami.craigslist.org/brw/cto/d/pompano-beach-2010-vw-jetta/7760130431.html | Florida | jetta | black | gas | NaN | sedan | automatic | 80 |